Introduction
The Upper Room at Azure North is a premier Christian-themed sanctuary staycation suite located in Barbados Tower 2610, Azure North, San Fernando, Pampanga, Philippines. Created by hosts Crisselle Joy & Francisnasser, the property is designed to provide families, couples, and traveling groups a peaceful sanctuary where faith meets genuine Filipino hospitality.
Like many boutique short-term rental operators, the property originally relied heavily on third-party Online Travel Agencies (OTAs) such as Airbnb and Agoda. While these platforms provided initial discoverability, they extracted between 15% to 20% in platform commissions on every stay, strictly shielded guest contact information, and offered zero mechanisms to convert casual social media visitors into loyal direct clients.
This project was engineered to establish a complete direct-to-guest booking engine
and digital acquisition ecosystem. From a 10% welcome voucher funnel (index.html) to an
interactive 3-step booking calendar (Booking.html),
automated GCash downpayment proofs, and a serverless Google Workspace backend (Codepromo.gs)—the
entire system operates with zero ongoing monthly software overhead.
Operational Challenges
Prior to engineering this bespoke system, the unit owners encountered several operational bottlenecks, revenue leaks, and administrative hurdles that constrained property scalability.
Severe OTA Commission Drag (15%–20% Revenue Loss)
Relying exclusively on commercial OTA platforms cut heavily into operational profit margins while preventing the hosts from establishing direct relationships with their returning clientele.
Scattered Inquiries & Response Lag
Inquiries arrived across Facebook Messenger, Instagram DMs, and personal phone calls. Late responses during busy hours led prospective guests to book competing units at Azure North.
Calendar Double-Booking Anxiety
Without an automated, centralized calendar synchronization engine, checking dates required manually cross-referencing paper notes and chats, risking overlapping reservation promises.
Zero Fence-Sitter Lead Capture
Social media ad visitors who were interested but not ready to book immediately bounced without leaving contact information, causing marketing expenditures to leak away untracked.
Clunky Manual GCash Payment Verification
Guests sent unstandardized payment screenshots through personal chat threads. Staff had to manually verify reference numbers and match bank transactions with no centralized audit trail.
Unstructured Government ID Handling
Collecting guest IDs via informal social messages raised serious compliance concerns under the Philippines Data Privacy Act of 2012 (RA 10173) with zero secure document storage.
Solution Implementation
To eliminate manual overhead and third-party fees, a unified direct-booking web application was engineered, pairing high-converting static frontends with an asynchronous, serverless Google Cloud & Google Workspace backend.
10% Welcome Voucher Generator (index.html): Engineered a high-converting lead capture gateway that mints single-use cryptographic voucher tokens (e.g.
UPR-XXXXXX). Captures guest name, mobile, and email while
immediately pre-populating discounts in the booking wizard.
Warm Luxury Showcase & Amenity Tour (home.html): Crafted a responsive brand narrative showcasing Azure North's world-class wave pool, unit amenities, verified testimonials marquee, and an interactive floating FAQ widget (
FAQwidget.html) answering common questions 24/7.
3-Step Dynamic Reservation Wizard (Booking.html): Developed an interactive date picker featuring automated pricing logic (📅 Weekdays Rate (Mon–Thu) ₱2,800 / night Includes 2 pax • ➕ ₱250 per extra pax, and 📅 Weekend Rate (Fri–Sun) ₱3,000 / night Includes 2 pax • ➕ ₱300 per extra pax). Includes flexible downpayment options (₱500 reservation hold, 50% deposit, or full payment).
Base64 to Google Drive Cloud Storage: Built a zero-CORS client-side compression pipeline. Guest government IDs and GCash payment screenshots are safely converted to Base64, transmitted via Apps Script, and stored as public viewable blobs in dedicated Google Drive folders.
Structured 6-Tab Google Sheets CRM: Normalized operational database tabs—
Leads, Bookings, Checkouts,
BlockedDates, Holidays, and Settings—enabling real-time pipeline management without recurring
database subscription fees.
6-Stream Automated HTML Email Notifications: Integrated transactional email dispatching via the Gmail API. Delivers instant booking confirmations to guests with check-in instructions while dispatching detailed booking alerts with 1-click verification links directly to host inboxes.
Measurable Results
Thankyou.html), the guest experience matches five-star hotel
standards.